﻿CREATE TABLE [dbo].[MsgContent] (
    [Id]         BIGINT            IDENTITY (1, 1) NOT NULL,
    [BkMemberId] BIGINT            CONSTRAINT [DF_MsgContent_BkMemberId] DEFAULT -1 NOT NULL,
    [WxUserId]   BIGINT  CONSTRAINT [DF_MsgContent_WxUserId] DEFAULT -1 NOT NULL,
    [Contents]   NTEXT NULL,
    [Title]      NVARCHAR(1000) NULL,
    [Status]     INT            NOT NULL,
    [UpdateTime] DATETIME       NOT NULL,
    [CreatTime]  DATETIME       NOT NULL,
    CONSTRAINT [PK_MsgContent] PRIMARY KEY CLUSTERED ([Id] ASC)
);




GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'数据创建时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgContent', @level2type = N'COLUMN', @level2name = N'CreatTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'读取时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgContent', @level2type = N'COLUMN', @level2name = N'UpdateTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0表示未读，1表示已读', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgContent', @level2type = N'COLUMN', @level2name = N'Status';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'通知内容概要', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgContent', @level2type = N'COLUMN', @level2name = N'Title';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'通知内容(json格式)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgContent', @level2type = N'COLUMN', @level2name = N'Contents';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户Id', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'MsgContent', @level2type = N'COLUMN', @level2name = N'BkMemberId';

